package com.xuan.webfinally.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.mybatis.spring.annotation.MapperScan;

@Mapper
public interface HomePageMapper {
   
    @Select("select count(*) from slope_info;")
    int getSumOfJcxm();
    @Select("select count(*) from slope_warning_info;")
    int getyujingcs();
    @Select("SELECT COUNT(*) FROM slope_warning_info WHERE warning_disposal = 1")
    int getxzyh();


    @Select("SELECT COUNT(*) FROM slope_warning_info WHERE warning_level = '红色双控预警' AND del_flag = '0'")
    int countRedWarning();

    @Select("SELECT COUNT(*) FROM slope_warning_info WHERE warning_level = '黄色单控预警' AND del_flag = '0'")
    int countYellowWarning();

    @Select("SELECT COUNT(*) FROM slope_warning_info WHERE warning_level = '蓝色单控预警' AND del_flag = '0'")
    int countBlueWarning();

    @Select("SELECT COUNT(*) FROM slope_warning_info WHERE warning_level = '橙色单控预警' AND del_flag = '0'")
    int countOrangeWarning();

}
